AdConcentration 
Logical Entity Name  AdConcentration 
Default Table Name  AdConcentration 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

AdConcentration Columns 
ColumnName  Domain  Datatype  NULL  Definition 
AdConcentrationID(PK)    int  NO 
 
Code    varchar(8)  NO 
 
Descrip    varchar(120)  NO 
 
SyCampusGrpID(FK)    int  NO 
 
Active    bit  NO 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
MinGPA    numeric(11, 6)  YES 
 
CreditsReq    numeric(9, 2)  YES 
 
AdConcentrationTypeID(FK)    int  NO 
 
CIPCode(FK)    varchar(7)  YES 
 
CrmSuppressFlag    bit  NO 
 
CurrentAdCIPCodeYearId(FK)    int  YES 
 
overallApprovedTransferCredit    money  NO 
 
TotalApprovedTransferCredit    money  YES 
 

AdConcentration Primary and Unique Keys 
Key Name  Key Type  Keys 
AdConcentration_SyCampusGrpID_U_N_IDX  Index  SyCampusGrpID 
AdConcentration_AdConcentrationID_U_C_IDX  PrimaryKey  AdConcentrationID 
AdConcentration_Code_U_N_IDX  Index  Code 

AdConcentration Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdConcentrationType  Non-Identifying  One To Zero or More  FK_AdConcentration.AdConcentrationTypeID_AdConcentrationType.AdConcentrationTypeID      AdConcentrationTypeID  NO  YES 
adCIPCode  Non-Identifying  Zero or One to Zero or More  FK_AdConcentration_CIPCode_adCIPCode_CIPCode      CIPCode  NO  YES 
AdCIPCodeYear  Non-Identifying  Zero or One to Zero or More  FK_AdConcentration_CurrentAdCIPCodeYearId_AdCIPCodeYear_AdCIPCodeYearId      CurrentAdCIPCodeYearId  NO  YES 
SyCampusGrp  Non-Identifying  One To Zero or More  FK_AdConcentration_SyCampusGrpID_SyCampusGrp_SyCampusGrpID      SyCampusGrpID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_AdConcentration_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdApprovedTransferCreditRestrictions  Non-Identifying  One To Zero or More  FK_AdApprovedTransferCreditRestrictions_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
AdCipCodeReporting  Non-Identifying  One To Zero or More  FK_AdCipCodeReporting_AdConcentrationId_AdConcentration_AdConcentrationID        NO  YES 
AdConcentrationByProgramVersion  Non-Identifying  One To Zero or More  FK_AdConcentrationByProgramVersion_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
adConcentrationExternalMap  Non-Identifying  One To Zero or More  FK_adConcentrationExternalMapadConcentrationId_adConcentrationadConcentrationId        NO  YES 
AdConcentrationRequirementRule  Non-Identifying  One To Zero or More  FK_AdConcentrationRequirementRule_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
AdDegreePathwayTemplate  Non-Identifying  One To Zero or More  FK_AdDegreePathwayTemplate_AdConcentrationId_AdConcentration_AdConcentrationID        NO  YES 
AdEnrollDegreeAuditCourseCategory  Non-Identifying  One To Zero or More  FK_AdEnrollDegreeAuditCourseCategory_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
AdEnrollDegreeAuditRequirementRule  Non-Identifying  One To Zero or More  FK_AdEnrollDegreeAuditRequirementRule_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
AdMajorConcentration  Non-Identifying  One To Zero or More  FK_AdMajorConcentration.AdConcentrationID_AdConcentration.AdConcentrationID        NO  YES 
AdMajorConcentration  Non-Identifying  One To Zero or More  FK_AdMajorConcentration.AdMajorID_AdConcentration.AdConcentrationID        NO  YES 
AdProgramCourse  Non-Identifying  One To Zero or More  FK_AdProgramCourse.AdConcentrationID_AdConcentration.AdConcentrationID        NO  YES 
AdProgramCourseCategory  Non-Identifying  One To Zero or More  FK_AdProgramCourseCategory.AdConcentrationID_AdConcentration.AdConcentrationID        NO  YES 
AdStudentDegreePathway  Non-Identifying  One To Zero or More  FK_AdStudentDegreePathway_AdConcentrationId_AdConcentration_AdConcentrationID        NO  YES 
AmOnlineApplicantConcentration  Non-Identifying  One To Zero or More  FK_AmOnlineApplicantConcentration_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
FaProgramVersionCOA  Non-Identifying  One To Zero or More  FK_FaProgramVersionCOA_AdConcentrationId_AdConcentration_AdConcentrationId        NO  YES 

AdConcentration Check Constraints 
Check Constraint Name  CheckConstraint 

AdConcentration Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

AdConcentration Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.AreaOfStudy 
NO       
Physical (Microsoft SQL Server)
dbo.AdConcentration 
NO       

AdConcentration Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  DegreePathway 
Logical  Program/ProgramVersion 
Logical  StudentEnrollment 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 

AdConcentration Data Movement Rules 
Name  Type  Rule Text/Value